﻿CREATE PROCEDURE [dbo].[proc_CallCenter_GetItem]
	(
		@GId uniqueidentifier
	)
AS
	Select
		Id,
		GId,
		CompanyId,
		DepartmentId,
		UserName,
		EName,
		ZXNum,
		FJNum,
		(Select  CompanyName From Company Where Id=CallCenter.CompanyId) As Company,
		(Select  DName From Department Where Id=CallCenter.DepartmentId) As Department
	From CallCenter Where GId=@GId
	RETURN
